﻿declare @brand as varchar(100) = 'American Crew'

select count(*) 
from Warehouse.dbo.product p
	inner join Warehouse.dbo.productname n on p.productnameid = n.id
	inner join Warehouse.dbo.Brand b on n.BrandId = b.id
	inner join Warehouse.dbo.UPC u on u.ProductId = p.Id
where b.Name = @brand